WordPress database error: [Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation 'like']
SELECT SQL_CALC_FOUND_ROWS sp_posts.ID FROM sp_posts WHERE 1=1 AND (((sp_posts.post_title LIKE '%[acc6.top]%') OR (sp_posts.post_excerpt LIKE '%[acc6.top]%') OR (sp_posts.post_content LIKE '%[acc6.top]%')) AND ((sp_posts.post_title LIKE '%Amazon%') OR (sp_posts.post_excerpt LIKE '%Amazon%') OR (sp_posts.post_content LIKE '%Amazon%')) AND ((sp_posts.post_title LIKE '%账户交易%') OR (sp_posts.post_excerpt LIKE '%账户交易%') OR (sp_posts.post_content LIKE '%账户交易%'))) AND (sp_posts.post_password = '') AND sp_posts.post_type IN ('post', 'page', 'attachment') AND (sp_posts.post_status = 'publish') ORDER BY (CASE WHEN sp_posts.post_title LIKE '%[acc6.top] Amazon 账户交易%' THEN 1 WHEN sp_posts.post_title LIKE '%[acc6.top]%' AND sp_posts.post_title LIKE '%Amazon%' AND sp_posts.post_title LIKE '%账户交易%' THEN 2 WHEN sp_posts.post_title LIKE '%[acc6.top]%' OR sp_posts.post_title LIKE '%Amazon%' OR sp_posts.post_title LIKE '%账户交易%' THEN 3 WHEN sp_posts.post_excerpt LIKE '%[acc6.top] Amazon 账户交易%' THEN 4 WHEN sp_posts.post_content LIKE '%[acc6.top] Amazon 账户交易%' THEN 5 ELSE 6 END), sp_posts.post_date DESC LIMIT 0, 10